<?php
#
#
# Copyright TEDECO, 2009. http://tedeco.fi.upm.es
#
# This file is part of kumenya.
#
# Kumenya is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# Kumenya is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with Foobar.  If not, see <http://www.gnu.org/licenses/>.
#
#
#
?>
<?php
class Magazine
{
	static public function getFields () {
		$dbManager = new DBManager();
		return $dbManager->TableFields (MagazinesTable,Library);
	}
	
	static public function Register ($filledFields) {
		$dbManager = new DBManager();
		$result = $dbManager->ExecuteProcedure ('NewMagazine',Library,$filledFields);
		if ($result)
			Interfaz::Result($dbManager->GetResult());
		else
			Interfaz::Error($dbManager->GetError());
		return $result;		
	}

	static public function Search ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteSearchProcedure ('SearchMagazine',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function GetStatistics ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->SearchStatistics ('SearchMagazineStatistics',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function SearchAvailable ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteSearchProcedure ('SearchAvailableMagazines',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function AvailableStatistics ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->SearchStatistics ('AvailableMagazinesStatistics',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function SearchLent ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteSearchProcedure ('SearchLentMagazines',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function LentStatistics ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->SearchStatistics ('LentMagazinesStatistics',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function LoansStatistics ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->SearchStatistics ('SearchLoanMagazinesStats',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function ReservationsStatistics ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->SearchStatistics ('SearchMagazinesReservationStats',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function SearchReserved ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteSearchProcedure ('SearchReservedMagazines',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function ReservedStatistics ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->SearchStatistics ('ReservedMagazinesStatistics',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}
	
	static public function SearchOnlyReserved ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteSearchProcedure ('SearchOnlyReservedMagazines',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}
	
	static public function OnlyReservedStatistics ($criterias) {
		$dbManager = new DBManager();
		$table = $dbManager->SearchStatistics ('OnlyReservedMagazinesStatistics',Library, $criterias);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}
	
	static public function SeeDetails ($identifier) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteSearchProcedure ('MagazineDetail',Library, $identifier);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function Modify ($filledFields) {
		$dbManager = new DBManager();
		$result = $dbManager->ExecuteProcedure ('MagazineModification',Library,$filledFields);		
		if ($result)
			Interfaz::Result($dbManager->GetResult());
		else
			Interfaz::Error($dbManager->GetError());
		return $result;		
	}

	static public function ReportByDates ($filledFields) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteProcedureReport ('LentMagazinesWhile',Library,$filledFields);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}

	static public function ReportByPeople ($filledFields) {
		$dbManager = new DBManager();
		$table = $dbManager->ExecuteProcedureReport ('MagazinesLentTo',Library,$filledFields);
		if (!is_array($table)) {
			Interfaz::Error($dbManager->GetError());
			return FALSE;
		}
		return $table;
	}
		
}

?>